Derby : Create/Rename/Drop Index

Categories: Database; Tagged with: Derby; @ September 16th, 2010 15:39

1. Create Index 创建, See: CREATE INDEX statement
   

   CREATE INDEX Employee_employee_ID_IDX ON Employee4(employee_ID);

2. Rename Index 重命名, See: RENAME INDEX statement
   

   RENAME INDEX EMPLOYEE_NAME_IDX TO EMPLOYEE2_NAME_IDX

3. Drop Index 删除 See: DROP INDEX statement
   

   DROP INDEX OrigIndex

又到八月初八 <-> Derby: Create auto-increment Column 创建自增Column

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects